Relatório de criação de perfil do Pandas

Dataset statistics

Number of variables	9
Number of observations	706
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	49.8 KiB
Average record size in memory	72.2 B

Variable types

NUM	8
DATE	1

Warnings

`High` is highly correlated with `Open` and 3 other fields	High correlation
`Open` is highly correlated with `High` and 3 other fields	High correlation
`Low` is highly correlated with `Open` and 3 other fields	High correlation
`Close` is highly correlated with `Open` and 3 other fields	High correlation
`Adj Close` is highly correlated with `Open` and 3 other fields	High correlation
`df_index` has unique values	Unique
`Date` has unique values	Unique
`Variation` has 10 (1.4%) zeros	Zeros

Reproduction

Analysis started	2020-11-12 07:07:07.531129
Analysis finished	2020-11-12 07:07:29.407701
Duration	21.88 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	706
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	354.3031161
Minimum	0
Maximum	708
Zeros	1
Zeros (%)	0.1%
Memory size	5.5 KiB

Quantile statistics

Minimum	0
5-th percentile	36.25
Q1	177.25
median	354.5
Q3	531.5
95-th percentile	672.75
Maximum	708
Range	708
Interquartile range (IQR)	354.25

Descriptive statistics

Standard deviation	204.7611829
Coefficient of variation (CV)	0.5779265651
Kurtosis	-1.200270634
Mean	354.3031161
Median Absolute Deviation (MAD)	177.5
Skewness	0.0003630745736
Sum	250138
Variance	41927.14203
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
708	1	0.1%
177	1	0.1%
241	1	0.1%
240	1	0.1%
239	1	0.1%
238	1	0.1%
237	1	0.1%
236	1	0.1%
235	1	0.1%
234	1	0.1%
Other values (696)	696	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%

Value	Count	Frequency (%)
708	1	0.1%
707	1	0.1%
706	1	0.1%
705	1	0.1%
704	1	0.1%

Date
Date

UNIQUE

Distinct	706
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	5.5 KiB

Minimum	2018-01-02 00:00:00
Maximum	2020-11-10 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Open
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	542
Distinct (%)	76.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.4308357
Minimum	11.07
Maximum	30.889999
Zeros	0
Zeros (%)	0.0%
Memory size	5.5 KiB

Quantile statistics

Minimum	11.07
5-th percentile	16.10999975
Q1	19.9550005
median	23.285001
Q3	27.02
95-th percentile	29.860001
Maximum	30.889999
Range	19.819999
Interquartile range (IQR)	7.0649995

Descriptive statistics

Standard deviation	4.358424213
Coefficient of variation (CV)	0.1860123245
Kurtosis	-0.7895191096
Mean	23.4308357
Median Absolute Deviation (MAD)	3.575
Skewness	-0.277854466
Sum	16542.17001
Variance	18.99586162
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.5	5	0.7%
27.549999	5	0.7%
22.540001	5	0.7%
26.799999	4	0.6%
26.17	4	0.6%
21.4	4	0.6%
26.299999	4	0.6%
26.35	4	0.6%
27.35	4	0.6%
25.5	4	0.6%
Other values (532)	663	93.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11.07	1	0.1%
11.79	1	0.1%
12.11	1	0.1%
12.57	1	0.1%
12.91	1	0.1%

Value	Count	Frequency (%)
30.889999	2	0.3%
30.879999	1	0.1%
30.82	1	0.1%
30.799999	1	0.1%
30.690001	2	0.3%

High
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	539
Distinct (%)	76.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.76616144
Minimum	12.18
Maximum	31.24
Zeros	0
Zeros (%)	0.0%
Memory size	5.5 KiB

Quantile statistics

Minimum	12.18
5-th percentile	16.549999
Q1	20.2625
median	23.5550005
Q3	27.3475
95-th percentile	30.25499975
Maximum	31.24
Range	19.06
Interquartile range (IQR)	7.085

Descriptive statistics

Standard deviation	4.319646858
Coefficient of variation (CV)	0.181756186
Kurtosis	-0.852538889
Mean	23.76616144
Median Absolute Deviation (MAD)	3.5149995
Skewness	-0.2550146266
Sum	16778.90998
Variance	18.65934898
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21.459999	5	0.7%
25.559999	4	0.6%
25.5	4	0.6%
28	4	0.6%
25.92	4	0.6%
22.629999	3	0.4%
21.469999	3	0.4%
18.4	3	0.4%
19.77	3	0.4%
25.719999	3	0.4%
Other values (529)	670	94.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12.18	1	0.1%
12.27	1	0.1%
13.07	1	0.1%
13.5	1	0.1%
13.54	1	0.1%

Value	Count	Frequency (%)
31.24	1	0.1%
31.23	1	0.1%
31.219999	1	0.1%
31.07	1	0.1%
31.049999	1	0.1%

Low
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	547
Distinct (%)	77.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.05358354
Minimum	10.85
Maximum	30.5
Zeros	0
Zeros (%)	0.0%
Memory size	5.5 KiB

Quantile statistics

Minimum	10.85
5-th percentile	15.53
Q1	19.6525
median	22.959999
Q3	26.7074995
95-th percentile	29.57499975
Maximum	30.5
Range	19.65
Interquartile range (IQR)	7.0549995

Descriptive statistics

Standard deviation	4.393272452
Coefficient of variation (CV)	0.1905678761
Kurtosis	-0.7102022948
Mean	23.05358354
Median Absolute Deviation (MAD)	3.514998
Skewness	-0.3112842768
Sum	16275.82998
Variance	19.30084283
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.059999	6	0.8%
17.65	4	0.6%
22.52	4	0.6%
26.629999	3	0.4%
26.639999	3	0.4%
25.85	3	0.4%
27.360001	3	0.4%
25.809999	3	0.4%
26.1	3	0.4%
18.620001	3	0.4%
Other values (537)	671	95.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10.85	1	0.1%
10.87	1	0.1%
11.08	1	0.1%
11.28	1	0.1%
11.83	1	0.1%

Value	Count	Frequency (%)
30.5	1	0.1%
30.48	1	0.1%
30.469999	1	0.1%
30.450001	1	0.1%
30.42	1	0.1%

Close
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	548
Distinct (%)	77.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.3967847
Minimum	11.29
Maximum	30.969999
Zeros	0
Zeros (%)	0.0%
Memory size	5.5 KiB

Quantile statistics

Minimum	11.29
5-th percentile	16.069999
Q1	19.98
median	23.2449995
Q3	27
95-th percentile	29.915
Maximum	30.969999
Range	19.679999
Interquartile range (IQR)	7.02

Descriptive statistics

Standard deviation	4.359761474
Coefficient of variation (CV)	0.1863401972
Kurtosis	-0.7840560115
Mean	23.3967847
Median Absolute Deviation (MAD)	3.5150005
Skewness	-0.2766612282
Sum	16518.13
Variance	19.00752011
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27.6	5	0.7%
26.24	3	0.4%
26.52	3	0.4%
21.67	3	0.4%
22.73	3	0.4%
27.34	3	0.4%
28.059999	3	0.4%
28.780001	3	0.4%
27.51	3	0.4%
28	3	0.4%
Other values (538)	674	95.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11.29	1	0.1%
11.5	1	0.1%
12	1	0.1%
12.21	1	0.1%
12.6	1	0.1%

Value	Count	Frequency (%)
30.969999	1	0.1%
30.91	1	0.1%
30.9	1	0.1%
30.809999	1	0.1%
30.700001	1	0.1%

Adj Close
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	659
Distinct (%)	93.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22.64901371
Minimum	11.289165
Maximum	30.80772
Zeros	0
Zeros (%)	0.0%
Memory size	5.5 KiB

Quantile statistics

Minimum	11.289165
5-th percentile	15.446153
Q1	19.24320125
median	22.8947725
Q3	26.18594925
95-th percentile	29.615361
Maximum	30.80772
Range	19.518555
Interquartile range (IQR)	6.942748

Descriptive statistics

Standard deviation	4.422245294
Coefficient of variation (CV)	0.19525112
Kurtosis	-0.8498468137
Mean	22.64901371
Median Absolute Deviation (MAD)	3.423383
Skewness	-0.1688080378
Sum	15990.20368
Variance	19.55625344
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.73	3	0.4%
21.469574	3	0.4%
27.100395	2	0.3%
27.041609	2	0.3%
17.941769	2	0.3%
20.129999	2	0.3%
27.097839	2	0.3%
14.036326	2	0.3%
17.100052	2	0.3%
25.983459	2	0.3%
Other values (649)	684	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11.289165	1	0.1%
11.49915	1	0.1%
11.999112	1	0.1%
12.209097	1	0.1%
12.599069	1	0.1%

Value	Count	Frequency (%)
30.80772	1	0.1%
30.697731	1	0.1%
30.687731	1	0.1%
30.547739	1	0.1%
30.544981	1	0.1%

Volume
Real number (ℝ_≥0)

Distinct	704
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	64859370.96
Minimum	0
Maximum	254813800
Zeros	1
Zeros (%)	0.1%
Memory size	5.5 KiB

Quantile statistics

Minimum	0
5-th percentile	29218450
Q1	43095225
median	56517400
Q3	75712325
95-th percentile	130171950
Maximum	254813800
Range	254813800
Interquartile range (IQR)	32617100

Descriptive statistics

Standard deviation	33207988.44
Coefficient of variation (CV)	0.5119998536
Kurtosis	5.500376542
Mean	64859370.96
Median Absolute Deviation (MAD)	15810650
Skewness	1.933092928
Sum	4.57907159e+10
Variance	1.102770496e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37053900	2	0.3%
28577400	2	0.3%
57658400	1	0.1%
74622500	1	0.1%
53106300	1	0.1%
61494800	1	0.1%
33336000	1	0.1%
37699000	1	0.1%
86794800	1	0.1%
107092400	1	0.1%
Other values (694)	694	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
19049900	1	0.1%
20809900	1	0.1%
21124400	1	0.1%
21970200	1	0.1%

Value	Count	Frequency (%)
254813800	1	0.1%
240343800	1	0.1%
234951200	1	0.1%
227307600	1	0.1%
216954700	1	0.1%

Variation
Real number (ℝ)

ZEROS

Distinct	420
Distinct (%)	59.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-0.0340510085
Minimum	-3.399999
Maximum	1.51
Zeros	10
Zeros (%)	1.4%
Memory size	5.5 KiB

Quantile statistics

Minimum	-3.399999
5-th percentile	-0.77000025
Q1	-0.3200015
median	-0.039999
Q3	0.24
95-th percentile	0.7874995
Maximum	1.51
Range	4.909999
Interquartile range (IQR)	0.5600015

Descriptive statistics

Standard deviation	0.4916476821
Coefficient of variation (CV)	-14.43856449
Kurtosis	3.78152019
Mean	-0.0340510085
Median Absolute Deviation (MAD)	0.279999
Skewness	-0.514276296
Sum	-24.040012
Variance	0.2417174433
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10	1.4%
-0.34	10	1.4%
-0.020001	8	1.1%
-0.039999	8	1.1%
-0.25	8	1.1%
0.17	7	1.0%
-0.09	7	1.0%
-0.210001	5	0.7%
0.18	5	0.7%
-0.130001	5	0.7%
Other values (410)	633	89.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3.399999	1	0.1%
-2.290001	1	0.1%
-1.76	1	0.1%
-1.459999	1	0.1%
-1.449999	1	0.1%

Value	Count	Frequency (%)
1.51	1	0.1%
1.480002	1	0.1%
1.33	1	0.1%
1.299999	2	0.3%
1.190001	1	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	df_index	Date	Open	High	Low	Close	Adj Close	Volume	Variation
0	0	2018-01-02	16.190001	16.549999	16.190001	16.549999	15.353477	33461800.0	0.359998
1	1	2018-01-03	16.490000	16.719999	16.370001	16.700001	15.492632	55940900.0	0.210001
2	2	2018-01-04	16.780001	16.959999	16.620001	16.730000	15.520465	37064900.0	-0.050001
3	3	2018-01-05	16.700001	16.860001	16.570000	16.830000	15.613236	26958200.0	0.129999
4	4	2018-01-08	16.740000	17.030001	16.709999	17.030001	15.798776	28400000.0	0.290001
5	5	2018-01-09	17.030001	17.160000	16.959999	17.030001	15.798776	35070900.0	0.000000
6	6	2018-01-10	16.920000	17.049999	16.770000	16.799999	15.585404	28547700.0	-0.120001
7	7	2018-01-11	16.879999	17.299999	16.840000	17.250000	16.002871	37921500.0	0.370001
8	8	2018-01-12	17.040001	17.410000	17.020000	17.299999	16.049253	45912100.0	0.259998
9	9	2018-01-15	17.320000	17.440001	17.150000	17.350000	16.095642	28945400.0	0.030000

Last rows

	df_index	Date	Open	High	Low	Close	Adj Close	Volume	Variation
696	699	2020-10-27	20.260000	20.370001	19.809999	19.879999	19.879999	48978400.0	-0.380001
697	700	2020-10-28	19.350000	19.440001	18.670000	18.670000	18.670000	79247400.0	-0.680000
698	701	2020-10-29	18.430000	19.370001	17.740000	19.290001	19.290001	86794800.0	0.860001
699	702	2020-10-30	19.139999	19.540001	18.870001	18.940001	18.940001	64185100.0	-0.199998
700	703	2020-11-03	19.510000	19.900000	19.330000	19.650000	19.650000	66292400.0	0.140000
701	704	2020-11-04	20.010000	20.070000	19.270000	19.719999	19.719999	65777600.0	-0.290001
702	705	2020-11-05	19.950001	19.990000	19.719999	19.889999	19.889999	40874800.0	-0.060002
703	706	2020-11-06	19.549999	19.950001	19.540001	19.719999	19.719999	25635300.0	0.170000
704	707	2020-11-09	21.110001	22.690001	21.040001	21.610001	21.610001	164904100.0	0.500000
705	708	2020-11-10	21.889999	23.150000	21.809999	23.080000	23.080000	163732600.0	1.190001

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows